-
- Rate Projections Functions Walkthrough
- Accruals and Cash
- Repeating Formulae
- Range Names and References
- Optional Parameters
- Using PmtsPerYear
- Modelling Seasonality
- Calculating Interest
- Using Business Functions in VBA (Visual Basic for Applications)
- Array Functions
- Volatility
- Annual Equivalent Rates
- Array Function
- Auto Multi Functions
- Variable Plurality
- GoalSeek
- Have a variable called "base" or similar that is the length of the projection"s time period in months, and refer to this in all functions that require a Base variable.
- Have the timebase itself refer to the "base" variable, for example by using the DpM function.
- Periodically change "base" to a different value and re-run the model. You should see that the results are the same.
How To Run a model on different time bases | |
Running a model on different timebases is one of the most powerful features of the library. The library is designed such that, as much as possible, all functions will give the same overall result regardless of the timebase they are run on. So your quarterly projection should read the same as your annual one! Ensuring your model works on different timebases easily is really question of sticking to some rules: |